import pandas as pd
from sqlalchemy import create_engine




#   建立与mysql的连接     这里需要禁用ssl安全协议
connect=create_engine('mysql+mysqlconnector://root:123456@192.168.67.193:3307/source?ssl_disabled=True&charset=utf8mb4')


# data=pd.read_csv('order.csv',index_col=False)
# user_id=data['user_id'].drop_duplicates().values
# data['password']='123456'
#
# new_data=pd.DataFrame({'user_id':user_id,
#      'password':data['password'].head(69767)})
#
# new_data.to_csv('user_id_and_password.csv',index=False)




